TO_CHAR (number)

Purpose

This function converts a number into a string.

Syntax

to_char (number)::=

Usage Notes

For information about supported numeric formats, see Numeric format models.

Example

Copy 
SELECT TO_CHAR(12345.6789) TO_CHAR;

SELECT TO_CHAR(12345.67890, '9999999.999999999') TO_CHAR;

SELECT TO_CHAR(-12345.67890, '000G000G000D000000MI') TO_CHAR;